/****** Script to update LSInsight$SourceTablesMap with new source tables  ******/


--Inclued table for Hotel room availability report
UPDATE dbo.LSInsight$SourceTablesMap SET IncludeTable = 'TRUE' WHERE SourceTableName = 'Hotel Room Availability';

GO

UPDATE dbo.LSInsight$SourceTablesMap SET IncludeTable='TRUE' WHERE SourceTableName = 'Hotel Res_ Entry'

GO

UPDATE dbo.LSInsight$SourceTablesMap SET IncludeTable='FALSE' WHERE SourceTableName = 'Hotel Res_ Statistic'

GO

INSERT INTO dbo.LSInsight$SourceTablesMap values ('Hotel Guest Group','LSCHT Hotel Guest Group','TRUE');

GO

INSERT INTO dbo.LSInsight$SourceTablesMap values ('Hotel Res_ Guestlist','LSCHT Hotel Res_ Guestlist','TRUE');